SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}Lloret{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}' OR prCity = 'Lloret' OR prZip = 'Lloret' OR prStreet LIKE '{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}Lloret{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}' OR prCountry = 'Lloret') AND (prLocation LIKE '{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}de{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}' OR prCity = 'de' OR prZip = 'de' OR prStreet LIKE '{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}de{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}' OR prCountry = 'de') AND (prLocation LIKE '{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}Mar{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}' OR prCity = 'Mar' OR prZip = 'Mar' OR prStreet LIKE '{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}Mar{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}' OR prCountry = 'Mar') AND (prLocation LIKE '{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}Spain{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}Spain{3c37253828e2f76c8f6bc854298f80461406bfe00b1530312a294dc79a7036e5}' OR prCountry = 'Spain')